Overview

Brought to you by YData

Dataset statistics

Number of variables	36
Number of observations	119390
Missing cells	129425
Missing cells (%)	3.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	32.8 MiB
Average record size in memory	288.0 B

Variable types

Categorical	16
Numeric	14
Text	5
DateTime	1

Alerts

`agent` is highly overall correlated with `hotel`	High correlation
`arrival_date_month` is highly overall correlated with `arrival_date_week_number`	High correlation
`arrival_date_week_number` is highly overall correlated with `arrival_date_month`	High correlation
`assigned_room_type` is highly overall correlated with `reserved_room_type`	High correlation
`distribution_channel` is highly overall correlated with `market_segment`	High correlation
`hotel` is highly overall correlated with `agent`	High correlation
`is_canceled` is highly overall correlated with `reservation_status`	High correlation
`market_segment` is highly overall correlated with `distribution_channel`	High correlation
`reservation_status` is highly overall correlated with `is_canceled`	High correlation
`reserved_room_type` is highly overall correlated with `assigned_room_type`	High correlation
`children` is highly imbalanced (80.7%)	Imbalance
`babies` is highly imbalanced (97.2%)	Imbalance
`meal` is highly imbalanced (53.5%)	Imbalance
`distribution_channel` is highly imbalanced (63.2%)	Imbalance
`is_repeated_guest` is highly imbalanced (79.6%)	Imbalance
`reserved_room_type` is highly imbalanced (58.3%)	Imbalance
`assigned_room_type` is highly imbalanced (51.4%)	Imbalance
`deposit_type` is highly imbalanced (65.3%)	Imbalance
`customer_type` is highly imbalanced (50.6%)	Imbalance
`required_car_parking_spaces` is highly imbalanced (85.4%)	Imbalance
`agent` has 16340 (13.7%) missing values	Missing
`company` has 112593 (94.3%) missing values	Missing
`previous_cancellations` is highly skewed (γ1 = 24.45804872)	Skewed
`previous_bookings_not_canceled` is highly skewed (γ1 = 23.53979995)	Skewed
`phone-number` has unique values	Unique
`lead_time` has 6345 (5.3%) zeros	Zeros
`stays_in_weekend_nights` has 51998 (43.6%) zeros	Zeros
`stays_in_week_nights` has 7645 (6.4%) zeros	Zeros
`previous_cancellations` has 112906 (94.6%) zeros	Zeros
`previous_bookings_not_canceled` has 115770 (97.0%) zeros	Zeros
`booking_changes` has 101314 (84.9%) zeros	Zeros
`days_in_waiting_list` has 115692 (96.9%) zeros	Zeros
`adr` has 1959 (1.6%) zeros	Zeros
`total_of_special_requests` has 70318 (58.9%) zeros	Zeros

Reproduction

Analysis started	2025-01-15 23:57:17.062437
Analysis finished	2025-01-15 23:58:04.065197
Duration	47 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

hotel
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

City Hotel	79330
Resort Hotel	40060

Length

Max length	12
Median length	10
Mean length	10.671078
Min length	10

Characters and Unicode

Total characters	1274020
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Resort Hotel
2nd row	Resort Hotel
3rd row	Resort Hotel
4th row	Resort Hotel
5th row	Resort Hotel

Common Values

Value	Count	Frequency (%)
City Hotel	79330	66.4%
Resort Hotel	40060	33.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hotel	119390	50.0%
city	79330	33.2%
resort	40060	16.8%

Most occurring characters

Value	Count	Frequency (%)
t	238780	18.7%
o	159450	12.5%
e	159450	12.5%
	119390	9.4%
H	119390	9.4%
l	119390	9.4%
C	79330	6.2%
i	79330	6.2%
y	79330	6.2%
R	40060	3.1%
Other values (2)	80120	6.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	915850	71.9%
Uppercase Letter	238780	18.7%
Space Separator	119390	9.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	238780	26.1%
o	159450	17.4%
e	159450	17.4%
l	119390	13.0%
i	79330	8.7%
y	79330	8.7%
s	40060	4.4%
r	40060	4.4%

Uppercase Letter

Value	Count	Frequency (%)
H	119390	50.0%
C	79330	33.2%
R	40060	16.8%

Space Separator

Value	Count	Frequency (%)
	119390	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1154630	90.6%
Common	119390	9.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	238780	20.7%
o	159450	13.8%
e	159450	13.8%
H	119390	10.3%
l	119390	10.3%
C	79330	6.9%
i	79330	6.9%
y	79330	6.9%
R	40060	3.5%
s	40060	3.5%

Common

Value	Count	Frequency (%)
	119390	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1274020	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	238780	18.7%
o	159450	12.5%
e	159450	12.5%
	119390	9.4%
H	119390	9.4%
l	119390	9.4%
C	79330	6.2%
i	79330	6.2%
y	79330	6.2%
R	40060	3.1%
Other values (2)	80120	6.3%

is_canceled
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

0	75166
1	44224

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Most occurring characters

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119390	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119390	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

lead_time
Real number (ℝ)

Zeros

Distinct	479
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	104.01142

Minimum	0
Maximum	737
Zeros	6345
Zeros (%)	5.3%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	18
median	69
Q3	160
95-th percentile	320
Maximum	737
Range	737
Interquartile range (IQR)	142

Descriptive statistics

Standard deviation	106.8631
Coefficient of variation (CV)	1.027417
Kurtosis	1.6964488
Mean	104.01142
Median Absolute Deviation (MAD)	60
Skewness	1.3465499
Sum	12417923
Variance	11419.722
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6345	5.3%
1	3460	2.9%
2	2069	1.7%
3	1816	1.5%
4	1715	1.4%
5	1565	1.3%
6	1445	1.2%
7	1331	1.1%
8	1138	1.0%
12	1079	0.9%
Other values (469)	97427	81.6%

Value	Count	Frequency (%)
0	6345	5.3%
1	3460	2.9%
2	2069	1.7%
3	1816	1.5%
4	1715	1.4%
5	1565	1.3%
6	1445	1.2%
7	1331	1.1%
8	1138	1.0%
9	992	0.8%

Value	Count	Frequency (%)
737	1	< 0.1%
709	1	< 0.1%
629	17	< 0.1%
626	30	< 0.1%
622	17	< 0.1%
615	17	< 0.1%
608	17	< 0.1%
605	30	< 0.1%
601	17	< 0.1%
594	17	< 0.1%

arrival_date_year
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

2016	56707
2017	40687
2015	21996

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	477560
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2015
2nd row	2015
3rd row	2015
4th row	2015
5th row	2015

Common Values

Value	Count	Frequency (%)
2016	56707	47.5%
2017	40687	34.1%
2015	21996	18.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016	56707	47.5%
2017	40687	34.1%
2015	21996	18.4%

Most occurring characters

Value	Count	Frequency (%)
2	119390	25.0%
0	119390	25.0%
1	119390	25.0%
6	56707	11.9%
7	40687	8.5%
5	21996	4.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	477560	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	119390	25.0%
0	119390	25.0%
1	119390	25.0%
6	56707	11.9%
7	40687	8.5%
5	21996	4.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	477560	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	119390	25.0%
0	119390	25.0%
1	119390	25.0%
6	56707	11.9%
7	40687	8.5%
5	21996	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	477560	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	119390	25.0%
0	119390	25.0%
1	119390	25.0%
6	56707	11.9%
7	40687	8.5%
5	21996	4.6%

arrival_date_month
Categorical

High correlation

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

August	13877
July	12661
May	11791
October	11160
April	11089
Other values (7)	58812

Length

Max length	9
Median length	7
Mean length	5.9031828
Min length	3

Characters and Unicode

Total characters	704781
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	July
2nd row	July
3rd row	July
4th row	July
5th row	July

Common Values

Value	Count	Frequency (%)
August	13877	11.6%
July	12661	10.6%
May	11791	9.9%
October	11160	9.3%
April	11089	9.3%
June	10939	9.2%
September	10508	8.8%
March	9794	8.2%
February	8068	6.8%
November	6794	5.7%
Other values (2)	12709	10.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
august	13877	11.6%
july	12661	10.6%
may	11791	9.9%
october	11160	9.3%
april	11089	9.3%
june	10939	9.2%
september	10508	8.8%
march	9794	8.2%
february	8068	6.8%
november	6794	5.7%
Other values (2)	12709	10.6%

Most occurring characters

Value	Count	Frequency (%)
e	95619	13.6%
r	78190	11.1%
u	65351	9.3%
b	43310	6.1%
a	41511	5.9%
y	38449	5.5%
t	35545	5.0%
J	29529	4.2%
c	27734	3.9%
A	24966	3.5%
Other values (16)	224577	31.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	585391	83.1%
Uppercase Letter	119390	16.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	95619	16.3%
r	78190	13.4%
u	65351	11.2%
b	43310	7.4%
a	41511	7.1%
y	38449	6.6%
t	35545	6.1%
c	27734	4.7%
m	24082	4.1%
l	23750	4.1%
Other values (8)	111850	19.1%

Uppercase Letter

Value	Count	Frequency (%)
J	29529	24.7%
A	24966	20.9%
M	21585	18.1%
O	11160	9.3%
S	10508	8.8%
F	8068	6.8%
N	6794	5.7%
D	6780	5.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	704781	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	95619	13.6%
r	78190	11.1%
u	65351	9.3%
b	43310	6.1%
a	41511	5.9%
y	38449	5.5%
t	35545	5.0%
J	29529	4.2%
c	27734	3.9%
A	24966	3.5%
Other values (16)	224577	31.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	704781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	95619	13.6%
r	78190	11.1%
u	65351	9.3%
b	43310	6.1%
a	41511	5.9%
y	38449	5.5%
t	35545	5.0%
J	29529	4.2%
c	27734	3.9%
A	24966	3.5%
Other values (16)	224577	31.9%

arrival_date_week_number
Real number (ℝ)

High correlation

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.165173

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	16
median	28
Q3	38
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	13.605138
Coefficient of variation (CV)	0.50083018
Kurtosis	-0.98607718
Mean	27.165173
Median Absolute Deviation (MAD)	11
Skewness	-0.010014326
Sum	3243250
Variance	185.09979
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	3580	3.0%
30	3087	2.6%
32	3045	2.6%
34	3040	2.5%
18	2926	2.5%
21	2854	2.4%
28	2853	2.4%
17	2805	2.3%
20	2785	2.3%
29	2763	2.3%
Other values (43)	89652	75.1%

Value	Count	Frequency (%)
1	1047	0.9%
2	1218	1.0%
3	1319	1.1%
4	1487	1.2%
5	1387	1.2%
6	1508	1.3%
7	2109	1.8%
8	2216	1.9%
9	2117	1.8%
10	2149	1.8%

Value	Count	Frequency (%)
53	1816	1.5%
52	1195	1.0%
51	933	0.8%
50	1505	1.3%
49	1782	1.5%
48	1504	1.3%
47	1685	1.4%
46	1574	1.3%
45	1941	1.6%
44	2272	1.9%

arrival_date_day_of_month
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.798241

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7808295
Coefficient of variation (CV)	0.55581058
Kurtosis	-1.1871683
Mean	15.798241
Median Absolute Deviation (MAD)	8
Skewness	-0.002000454
Sum	1886152
Variance	77.102966
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
17	4406	3.7%
5	4317	3.6%
15	4196	3.5%
25	4160	3.5%
26	4147	3.5%
9	4096	3.4%
12	4087	3.4%
16	4078	3.4%
2	4055	3.4%
19	4052	3.4%
Other values (21)	77796	65.2%

Value	Count	Frequency (%)
1	3626	3.0%
2	4055	3.4%
3	3855	3.2%
4	3763	3.2%
5	4317	3.6%
6	3833	3.2%
7	3665	3.1%
8	3921	3.3%
9	4096	3.4%
10	3575	3.0%

Value	Count	Frequency (%)
31	2208	1.8%
30	3853	3.2%
29	3580	3.0%
28	3946	3.3%
27	3802	3.2%
26	4147	3.5%
25	4160	3.5%
24	3993	3.3%
23	3616	3.0%
22	3596	3.0%

stays_in_weekend_nights
Real number (ℝ)

Zeros

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.92759863

Minimum	0
Maximum	19
Zeros	51998
Zeros (%)	43.6%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	2
Maximum	19
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.99861349
Coefficient of variation (CV)	1.0765578
Kurtosis	7.1740661
Mean	0.92759863
Median Absolute Deviation (MAD)	1
Skewness	1.3800464
Sum	110746
Variance	0.99722891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	51998	43.6%
2	33308	27.9%
1	30626	25.7%
4	1855	1.6%
3	1259	1.1%
6	153	0.1%
5	79	0.1%
8	60	0.1%
7	19	< 0.1%
9	11	< 0.1%
Other values (7)	22	< 0.1%

Value	Count	Frequency (%)
0	51998	43.6%
1	30626	25.7%
2	33308	27.9%
3	1259	1.1%
4	1855	1.6%
5	79	0.1%
6	153	0.1%
7	19	< 0.1%
8	60	0.1%
9	11	< 0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
18	1	< 0.1%
16	3	< 0.1%
14	2	< 0.1%
13	3	< 0.1%
12	5	< 0.1%
10	7	< 0.1%
9	11	< 0.1%
8	60	0.1%
7	19	< 0.1%

stays_in_week_nights
Real number (ℝ)

Zeros

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5003015

Minimum	0
Maximum	50
Zeros	7645
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	50
Range	50
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.9082856
Coefficient of variation (CV)	0.76322219
Kurtosis	24.284555
Mean	2.5003015
Median Absolute Deviation (MAD)	1
Skewness	2.8622492
Sum	298511
Variance	3.641554
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
2	33684	28.2%
1	30310	25.4%
3	22258	18.6%
5	11077	9.3%
4	9563	8.0%
0	7645	6.4%
6	1499	1.3%
10	1036	0.9%
7	1029	0.9%
8	656	0.5%
Other values (25)	633	0.5%

Value	Count	Frequency (%)
0	7645	6.4%
1	30310	25.4%
2	33684	28.2%
3	22258	18.6%
4	9563	8.0%
5	11077	9.3%
6	1499	1.3%
7	1029	0.9%
8	656	0.5%
9	231	0.2%

Value	Count	Frequency (%)
50	1	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
40	2	< 0.1%
35	1	< 0.1%
34	1	< 0.1%
33	1	< 0.1%
32	1	< 0.1%
30	5	< 0.1%
26	1	< 0.1%

adults
Real number (ℝ)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8564034

Minimum	0
Maximum	55
Zeros	403
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	55
Range	55
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.579261
Coefficient of variation (CV)	0.31203401
Kurtosis	1352.1151
Mean	1.8564034
Median Absolute Deviation (MAD)	0
Skewness	18.317805
Sum	221636
Variance	0.3355433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2	89680	75.1%
1	23027	19.3%
3	6202	5.2%
0	403	0.3%
4	62	0.1%
26	5	< 0.1%
27	2	< 0.1%
20	2	< 0.1%
5	2	< 0.1%
40	1	< 0.1%
Other values (4)	4	< 0.1%

Value	Count	Frequency (%)
0	403	0.3%
1	23027	19.3%
2	89680	75.1%
3	6202	5.2%
4	62	0.1%
5	2	< 0.1%
6	1	< 0.1%
10	1	< 0.1%
20	2	< 0.1%
26	5	< 0.1%

Value	Count	Frequency (%)
55	1	< 0.1%
50	1	< 0.1%
40	1	< 0.1%
27	2	< 0.1%
26	5	< 0.1%
20	2	< 0.1%
10	1	< 0.1%
6	1	< 0.1%
5	2	< 0.1%
4	62	0.1%

children
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	932.9 KiB

0.0	110796
1.0	4861
2.0	3652
3.0	76
10.0	1

Length

Max length	4
Median length	3
Mean length	3.0000084
Min length	3

Characters and Unicode

Total characters	358159
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	110796	92.8%
1.0	4861	4.1%
2.0	3652	3.1%
3.0	76	0.1%
10.0	1	< 0.1%
(Missing)	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	110796	92.8%
1.0	4861	4.1%
2.0	3652	3.1%
3.0	76	0.1%
10.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	230183	64.3%
.	119386	33.3%
1	4862	1.4%
2	3652	1.0%
3	76	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	238773	66.7%
Other Punctuation	119386	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	230183	96.4%
1	4862	2.0%
2	3652	1.5%
3	76	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	119386	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	358159	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	230183	64.3%
.	119386	33.3%
1	4862	1.4%
2	3652	1.0%
3	76	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	358159	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	230183	64.3%
.	119386	33.3%
1	4862	1.4%
2	3652	1.0%
3	76	< 0.1%

babies
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

0	118473
1	900
2	15
10	1
9	1

Length

Max length	2
Median length	1
Mean length	1.0000084
Min length	1

Characters and Unicode

Total characters	119391
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	118473	99.2%
1	900	0.8%
2	15	< 0.1%
10	1	< 0.1%
9	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	118473	99.2%
1	900	0.8%
2	15	< 0.1%
10	1	< 0.1%
9	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	118474	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119391	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	118474	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	119391	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	118474	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119391	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	118474	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

meal
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

BB	92310
HB	14463
SC	10650
Undefined	1169
FB	798

Length

Max length	9
Median length	2
Mean length	2.0685401
Min length	2

Characters and Unicode

Total characters	246963
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BB
2nd row	BB
3rd row	BB
4th row	BB
5th row	BB

Common Values

Value	Count	Frequency (%)
BB	92310	77.3%
HB	14463	12.1%
SC	10650	8.9%
Undefined	1169	1.0%
FB	798	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bb	92310	77.3%
hb	14463	12.1%
sc	10650	8.9%
undefined	1169	1.0%
fb	798	0.7%

Most occurring characters

Value	Count	Frequency (%)
B	199881	80.9%
H	14463	5.9%
S	10650	4.3%
C	10650	4.3%
n	2338	0.9%
d	2338	0.9%
e	2338	0.9%
U	1169	0.5%
f	1169	0.5%
i	1169	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	237611	96.2%
Lowercase Letter	9352	3.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	199881	84.1%
H	14463	6.1%
S	10650	4.5%
C	10650	4.5%
U	1169	0.5%
F	798	0.3%

Lowercase Letter

Value	Count	Frequency (%)
n	2338	25.0%
d	2338	25.0%
e	2338	25.0%
f	1169	12.5%
i	1169	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	246963	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	199881	80.9%
H	14463	5.9%
S	10650	4.3%
C	10650	4.3%
n	2338	0.9%
d	2338	0.9%
e	2338	0.9%
U	1169	0.5%
f	1169	0.5%
i	1169	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	246963	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	199881	80.9%
H	14463	5.9%
S	10650	4.3%
C	10650	4.3%
n	2338	0.9%
d	2338	0.9%
e	2338	0.9%
U	1169	0.5%
f	1169	0.5%
i	1169	0.5%

country
Text

Distinct	177
Distinct (%)	0.1%
Missing	488
Missing (%)	0.4%
Memory size	932.9 KiB

Length

Max length	3
Median length	3
Mean length	2.9892432
Min length	2

Characters and Unicode

Total characters	355427
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	30 ?
Unique (%)	< 0.1%

Sample

1st row	PRT
2nd row	PRT
3rd row	GBR
4th row	GBR
5th row	GBR

Value	Count	Frequency (%)
prt	48590	40.9%
gbr	12129	10.2%
fra	10415	8.8%
esp	8568	7.2%
deu	7287	6.1%
ita	3766	3.2%
irl	3375	2.8%
bel	2342	2.0%
bra	2224	1.9%
nld	2104	1.8%
Other values (167)	18102	15.2%

Most occurring characters

Value	Count	Frequency (%)
R	80804	22.7%
P	58506	16.5%
T	54263	15.3%
A	21627	6.1%
E	21538	6.1%
B	17051	4.8%
S	13931	3.9%
U	13293	3.7%
G	13130	3.7%
F	10956	3.1%
Other values (16)	50328	14.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	355427	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	80804	22.7%
P	58506	16.5%
T	54263	15.3%
A	21627	6.1%
E	21538	6.1%
B	17051	4.8%
S	13931	3.9%
U	13293	3.7%
G	13130	3.7%
F	10956	3.1%
Other values (16)	50328	14.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	355427	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	80804	22.7%
P	58506	16.5%
T	54263	15.3%
A	21627	6.1%
E	21538	6.1%
B	17051	4.8%
S	13931	3.9%
U	13293	3.7%
G	13130	3.7%
F	10956	3.1%
Other values (16)	50328	14.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	355427	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	80804	22.7%
P	58506	16.5%
T	54263	15.3%
A	21627	6.1%
E	21538	6.1%
B	17051	4.8%
S	13931	3.9%
U	13293	3.7%
G	13130	3.7%
F	10956	3.1%
Other values (16)	50328	14.2%

market_segment
Categorical

High correlation

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Online TA	56477
Offline TA/TO	24219
Groups	19811
Direct	12606
Corporate	5295
Other values (3)	982

Length

Max length	13
Median length	9
Mean length	9.0197671
Min length	6

Characters and Unicode

Total characters	1076870
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	Direct
3rd row	Direct
4th row	Corporate
5th row	Online TA

Common Values

Value	Count	Frequency (%)
Online TA	56477	47.3%
Offline TA/TO	24219	20.3%
Groups	19811	16.6%
Direct	12606	10.6%
Corporate	5295	4.4%
Complementary	743	0.6%
Aviation	237	0.2%
Undefined	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
online	56477	28.2%
ta	56477	28.2%
offline	24219	12.1%
ta/to	24219	12.1%
groups	19811	9.9%
direct	12606	6.3%
corporate	5295	2.6%
complementary	743	0.4%
aviation	237	0.1%
undefined	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
n	138157	12.8%
O	104915	9.7%
T	104915	9.7%
e	100087	9.3%
i	93778	8.7%
l	81439	7.6%
A	80933	7.5%
	80696	7.5%
f	48440	4.5%
r	43750	4.1%
Other values (16)	199760	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	642735	59.7%
Uppercase Letter	329220	30.6%
Space Separator	80696	7.5%
Other Punctuation	24219	2.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	138157	21.5%
e	100087	15.6%
i	93778	14.6%
l	81439	12.7%
f	48440	7.5%
r	43750	6.8%
o	31381	4.9%
p	25849	4.0%
s	19811	3.1%
u	19811	3.1%
Other values (7)	40232	6.3%

Uppercase Letter

Value	Count	Frequency (%)
O	104915	31.9%
T	104915	31.9%
A	80933	24.6%
G	19811	6.0%
D	12606	3.8%
C	6038	1.8%
U	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	80696	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	24219	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	971955	90.3%
Common	104915	9.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	138157	14.2%
O	104915	10.8%
T	104915	10.8%
e	100087	10.3%
i	93778	9.6%
l	81439	8.4%
A	80933	8.3%
f	48440	5.0%
r	43750	4.5%
o	31381	3.2%
Other values (14)	144160	14.8%

Common

Value	Count	Frequency (%)
	80696	76.9%
/	24219	23.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1076870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	138157	12.8%
O	104915	9.7%
T	104915	9.7%
e	100087	9.3%
i	93778	8.7%
l	81439	7.6%
A	80933	7.5%
	80696	7.5%
f	48440	4.5%
r	43750	4.1%
Other values (16)	199760	18.6%

distribution_channel
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

TA/TO	97870
Direct	14645
Corporate	6677
GDS	193
Undefined	5

Length

Max length	9
Median length	5
Mean length	5.3433035
Min length	3

Characters and Unicode

Total characters	637937
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	Direct
3rd row	Direct
4th row	Corporate
5th row	TA/TO

Common Values

Value	Count	Frequency (%)
TA/TO	97870	82.0%
Direct	14645	12.3%
Corporate	6677	5.6%
GDS	193	0.2%
Undefined	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ta/to	97870	82.0%
direct	14645	12.3%
corporate	6677	5.6%
gds	193	0.2%
undefined	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
T	195740	30.7%
/	97870	15.3%
O	97870	15.3%
A	97870	15.3%
r	27999	4.4%
e	21332	3.3%
t	21322	3.3%
D	14838	2.3%
i	14650	2.3%
c	14645	2.3%
Other values (10)	33801	5.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	413386	64.8%
Lowercase Letter	126681	19.9%
Other Punctuation	97870	15.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	27999	22.1%
e	21332	16.8%
t	21322	16.8%
i	14650	11.6%
c	14645	11.6%
o	13354	10.5%
a	6677	5.3%
p	6677	5.3%
n	10	< 0.1%
d	10	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
T	195740	47.4%
O	97870	23.7%
A	97870	23.7%
D	14838	3.6%
C	6677	1.6%
G	193	< 0.1%
S	193	< 0.1%
U	5	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	97870	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	540067	84.7%
Common	97870	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	195740	36.2%
O	97870	18.1%
A	97870	18.1%
r	27999	5.2%
e	21332	3.9%
t	21322	3.9%
D	14838	2.7%
i	14650	2.7%
c	14645	2.7%
o	13354	2.5%
Other values (9)	20447	3.8%

Common

Value	Count	Frequency (%)
/	97870	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	637937	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	195740	30.7%
/	97870	15.3%
O	97870	15.3%
A	97870	15.3%
r	27999	4.4%
e	21332	3.3%
t	21322	3.3%
D	14838	2.3%
i	14650	2.3%
c	14645	2.3%
Other values (10)	33801	5.3%

is_repeated_guest
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

0	115580
1	3810

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Most occurring characters

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119390	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	119390	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

previous_cancellations
Real number (ℝ)

Skewed Zeros

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.087117849

Minimum	0
Maximum	26
Zeros	112906
Zeros (%)	94.6%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	26
Range	26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.84433638
Coefficient of variation (CV)	9.6918874
Kurtosis	674.07369
Mean	0.087117849
Median Absolute Deviation (MAD)	0
Skewness	24.458049
Sum	10401
Variance	0.71290393
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	112906	94.6%
1	6051	5.1%
2	116	0.1%
3	65	0.1%
24	48	< 0.1%
11	35	< 0.1%
4	31	< 0.1%
26	26	< 0.1%
25	25	< 0.1%
6	22	< 0.1%
Other values (5)	65	0.1%

Value	Count	Frequency (%)
0	112906	94.6%
1	6051	5.1%
2	116	0.1%
3	65	0.1%
4	31	< 0.1%
5	19	< 0.1%
6	22	< 0.1%
11	35	< 0.1%
13	12	< 0.1%
14	14	< 0.1%

Value	Count	Frequency (%)
26	26	< 0.1%
25	25	< 0.1%
24	48	< 0.1%
21	1	< 0.1%
19	19	< 0.1%
14	14	< 0.1%
13	12	< 0.1%
11	35	< 0.1%
6	22	< 0.1%
5	19	< 0.1%

previous_bookings_not_canceled
Real number (ℝ)

Skewed Zeros

Distinct	73
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13709691

Minimum	0
Maximum	72
Zeros	115770
Zeros (%)	97.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	72
Range	72
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.4974368
Coefficient of variation (CV)	10.92247
Kurtosis	767.24521
Mean	0.13709691
Median Absolute Deviation (MAD)	0
Skewness	23.5398
Sum	16368
Variance	2.2423171
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	115770	97.0%
1	1542	1.3%
2	580	0.5%
3	333	0.3%
4	229	0.2%
5	181	0.2%
6	115	0.1%
7	88	0.1%
8	70	0.1%
9	60	0.1%
Other values (63)	422	0.4%

Value	Count	Frequency (%)
0	115770	97.0%
1	1542	1.3%
2	580	0.5%
3	333	0.3%
4	229	0.2%
5	181	0.2%
6	115	0.1%
7	88	0.1%
8	70	0.1%
9	60	0.1%

Value	Count	Frequency (%)
72	1	< 0.1%
71	1	< 0.1%
70	1	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
67	1	< 0.1%
66	1	< 0.1%
65	1	< 0.1%
64	1	< 0.1%
63	1	< 0.1%

reserved_room_type
Categorical

High correlation Imbalance

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

A	85994
D	19201
E	6535
F	2897
G	2094
Other values (5)	2669

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	C
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	85994	72.0%
d	19201	16.1%
e	6535	5.5%
f	2897	2.4%
g	2094	1.8%
b	1118	0.9%
c	932	0.8%
h	601	0.5%
p	12	< 0.1%
l	6	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	119390	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119390	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

assigned_room_type
Categorical

High correlation Imbalance

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

A	74053
D	25322
E	7806
F	3751
G	2553
Other values (7)	5905

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	C
2nd row	C
3rd row	C
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	74053	62.0%
d	25322	21.2%
e	7806	6.5%
f	3751	3.1%
g	2553	2.1%
c	2375	2.0%
b	2163	1.8%
h	712	0.6%
i	363	0.3%
k	279	0.2%
Other values (2)	13	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	119390	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119390	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

booking_changes
Real number (ℝ)

Zeros

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.22112405

Minimum	0
Maximum	21
Zeros	101314
Zeros (%)	84.9%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.65230557
Coefficient of variation (CV)	2.9499531
Kurtosis	79.393605
Mean	0.22112405
Median Absolute Deviation (MAD)	0
Skewness	6.0002701
Sum	26400
Variance	0.42550256
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0	101314	84.9%
1	12701	10.6%
2	3805	3.2%
3	927	0.8%
4	376	0.3%
5	118	0.1%
6	63	0.1%
7	31	< 0.1%
8	17	< 0.1%
9	8	< 0.1%
Other values (11)	30	< 0.1%

Value	Count	Frequency (%)
0	101314	84.9%
1	12701	10.6%
2	3805	3.2%
3	927	0.8%
4	376	0.3%
5	118	0.1%
6	63	0.1%
7	31	< 0.1%
8	17	< 0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	1	< 0.1%
18	1	< 0.1%
17	2	< 0.1%
16	2	< 0.1%
15	3	< 0.1%
14	5	< 0.1%
13	5	< 0.1%
12	2	< 0.1%
11	2	< 0.1%

deposit_type
Categorical

Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

No Deposit	104641
Non Refund	14587
Refundable	162

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1193900
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Deposit
2nd row	No Deposit
3rd row	No Deposit
4th row	No Deposit
5th row	No Deposit

Common Values

Value	Count	Frequency (%)
No Deposit	104641	87.6%
Non Refund	14587	12.2%
Refundable	162	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	104641	43.9%
deposit	104641	43.9%
non	14587	6.1%
refund	14587	6.1%
refundable	162	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	223869	18.8%
e	119552	10.0%
N	119228	10.0%
	119228	10.0%
s	104641	8.8%
i	104641	8.8%
t	104641	8.8%
p	104641	8.8%
D	104641	8.8%
n	29336	2.5%
Other values (7)	59482	5.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	836054	70.0%
Uppercase Letter	238618	20.0%
Space Separator	119228	10.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	223869	26.8%
e	119552	14.3%
s	104641	12.5%
i	104641	12.5%
t	104641	12.5%
p	104641	12.5%
n	29336	3.5%
f	14749	1.8%
u	14749	1.8%
d	14749	1.8%
Other values (3)	486	0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	119228	50.0%
D	104641	43.9%
R	14749	6.2%

Space Separator

Value	Count	Frequency (%)
	119228	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1074672	90.0%
Common	119228	10.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	223869	20.8%
e	119552	11.1%
N	119228	11.1%
s	104641	9.7%
i	104641	9.7%
t	104641	9.7%
p	104641	9.7%
D	104641	9.7%
n	29336	2.7%
R	14749	1.4%
Other values (6)	44733	4.2%

Common

Value	Count	Frequency (%)
	119228	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1193900	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	223869	18.8%
e	119552	10.0%
N	119228	10.0%
	119228	10.0%
s	104641	8.8%
i	104641	8.8%
t	104641	8.8%
p	104641	8.8%
D	104641	8.8%
n	29336	2.5%
Other values (7)	59482	5.0%

agent
Real number (ℝ)

High correlation Missing

Distinct	333
Distinct (%)	0.3%
Missing	16340
Missing (%)	13.7%
Infinite	0
Infinite (%)	0.0%
Mean	86.693382

Minimum	1
Maximum	535
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	9
median	14
Q3	229
95-th percentile	250
Maximum	535
Range	534
Interquartile range (IQR)	220

Descriptive statistics

Standard deviation	110.77455
Coefficient of variation (CV)	1.277774
Kurtosis	-0.0071795649
Mean	86.693382
Median Absolute Deviation (MAD)	13
Skewness	1.0893856
Sum	8933753
Variance	12271
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	31961	26.8%
240	13922	11.7%
1	7191	6.0%
14	3640	3.0%
7	3539	3.0%
6	3290	2.8%
250	2870	2.4%
241	1721	1.4%
28	1666	1.4%
8	1514	1.3%
Other values (323)	31736	26.6%
(Missing)	16340	13.7%

Value	Count	Frequency (%)
1	7191	6.0%
2	162	0.1%
3	1336	1.1%
4	47	< 0.1%
5	330	0.3%
6	3290	2.8%
7	3539	3.0%
8	1514	1.3%
9	31961	26.8%
10	260	0.2%

Value	Count	Frequency (%)
535	3	< 0.1%
531	68	0.1%
527	35	< 0.1%
526	10	< 0.1%
510	2	< 0.1%
509	10	< 0.1%
508	6	< 0.1%
502	24	< 0.1%
497	1	< 0.1%
495	57	< 0.1%

company
Real number (ℝ)

Missing

Distinct	352
Distinct (%)	5.2%
Missing	112593
Missing (%)	94.3%
Infinite	0
Infinite (%)	0.0%
Mean	189.26674

Minimum	6
Maximum	543
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	6
5-th percentile	40
Q1	62
median	179
Q3	270
95-th percentile	435
Maximum	543
Range	537
Interquartile range (IQR)	208

Descriptive statistics

Standard deviation	131.65501
Coefficient of variation (CV)	0.69560567
Kurtosis	-0.49079521
Mean	189.26674
Median Absolute Deviation (MAD)	111
Skewness	0.60159967
Sum	1286446
Variance	17333.043
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	927	0.8%
223	784	0.7%
67	267	0.2%
45	250	0.2%
153	215	0.2%
174	149	0.1%
219	141	0.1%
281	138	0.1%
154	133	0.1%
405	119	0.1%
Other values (342)	3674	3.1%
(Missing)	112593	94.3%

Value	Count	Frequency (%)
6	1	< 0.1%
8	1	< 0.1%
9	37	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
12	14	< 0.1%
14	9	< 0.1%
16	5	< 0.1%
18	1	< 0.1%
20	50	< 0.1%

Value	Count	Frequency (%)
543	2	< 0.1%
541	1	< 0.1%
539	2	< 0.1%
534	2	< 0.1%
531	1	< 0.1%
530	5	< 0.1%
528	2	< 0.1%
525	15	< 0.1%
523	19	< 0.1%
521	7	< 0.1%

days_in_waiting_list
Real number (ℝ)

Zeros

Distinct	128
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.3211492

Minimum	0
Maximum	391
Zeros	115692
Zeros (%)	96.9%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	391
Range	391
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	17.594721
Coefficient of variation (CV)	7.5801767
Kurtosis	186.79307
Mean	2.3211492
Median Absolute Deviation (MAD)	0
Skewness	11.944353
Sum	277122
Variance	309.5742
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	115692	96.9%
39	227	0.2%
58	164	0.1%
44	141	0.1%
31	127	0.1%
35	96	0.1%
46	94	0.1%
69	89	0.1%
63	83	0.1%
87	80	0.1%
Other values (118)	2597	2.2%

Value	Count	Frequency (%)
0	115692	96.9%
1	12	< 0.1%
2	5	< 0.1%
3	59	< 0.1%
4	25	< 0.1%
5	8	< 0.1%
6	16	< 0.1%
7	4	< 0.1%
8	7	< 0.1%
9	16	< 0.1%

Value	Count	Frequency (%)
391	45	< 0.1%
379	15	< 0.1%
330	15	< 0.1%
259	10	< 0.1%
236	35	< 0.1%
224	10	< 0.1%
223	61	0.1%
215	21	< 0.1%
207	15	< 0.1%
193	1	< 0.1%

customer_type
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Transient	89613
Transient-Party	25124
Contract	4076
Group	577

Length

Max length	15
Median length	9
Mean length	10.209146
Min length	5

Characters and Unicode

Total characters	1218870
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Transient
2nd row	Transient
3rd row	Transient
4th row	Transient
5th row	Transient

Common Values

Value	Count	Frequency (%)
Transient	89613	75.1%
Transient-Party	25124	21.0%
Contract	4076	3.4%
Group	577	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
transient	89613	75.1%
transient-party	25124	21.0%
contract	4076	3.4%
group	577	0.5%

Most occurring characters

Value	Count	Frequency (%)
n	233550	19.2%
t	148013	12.1%
r	144514	11.9%
a	143937	11.8%
T	114737	9.4%
s	114737	9.4%
i	114737	9.4%
e	114737	9.4%
y	25124	2.1%
-	25124	2.1%
Other values (7)	39660	3.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1049232	86.1%
Uppercase Letter	144514	11.9%
Dash Punctuation	25124	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	233550	22.3%
t	148013	14.1%
r	144514	13.8%
a	143937	13.7%
s	114737	10.9%
i	114737	10.9%
e	114737	10.9%
y	25124	2.4%
o	4653	0.4%
c	4076	0.4%
Other values (2)	1154	0.1%

Uppercase Letter

Value	Count	Frequency (%)
T	114737	79.4%
P	25124	17.4%
C	4076	2.8%
G	577	0.4%

Dash Punctuation

Value	Count	Frequency (%)
-	25124	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1193746	97.9%
Common	25124	2.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	233550	19.6%
t	148013	12.4%
r	144514	12.1%
a	143937	12.1%
T	114737	9.6%
s	114737	9.6%
i	114737	9.6%
e	114737	9.6%
y	25124	2.1%
P	25124	2.1%
Other values (6)	14536	1.2%

Common

Value	Count	Frequency (%)
-	25124	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1218870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	233550	19.2%
t	148013	12.1%
r	144514	11.9%
a	143937	11.8%
T	114737	9.4%
s	114737	9.4%
i	114737	9.4%
e	114737	9.4%
y	25124	2.1%
-	25124	2.1%
Other values (7)	39660	3.3%

adr
Real number (ℝ)

Zeros

Distinct	8879
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	101.83112

Minimum	-6.38
Maximum	5400
Zeros	1959
Zeros (%)	1.6%
Negative	1
Negative (%)	< 0.1%
Memory size	932.9 KiB

Quantile statistics

Minimum	-6.38
5-th percentile	38.4
Q1	69.29
median	94.575
Q3	126
95-th percentile	193.5
Maximum	5400
Range	5406.38
Interquartile range (IQR)	56.71

Descriptive statistics

Standard deviation	50.53579
Coefficient of variation (CV)	0.49627059
Kurtosis	1013.1899
Mean	101.83112
Median Absolute Deviation (MAD)	27.825
Skewness	10.530214
Sum	12157618
Variance	2553.8661
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	3754	3.1%
75	2715	2.3%
90	2473	2.1%
65	2418	2.0%
0	1959	1.6%
80	1889	1.6%
95	1661	1.4%
120	1607	1.3%
100	1573	1.3%
85	1538	1.3%
Other values (8869)	97803	81.9%

Value	Count	Frequency (%)
-6.38	1	< 0.1%
0	1959	1.6%
0.26	1	< 0.1%
0.5	1	< 0.1%
1	15	< 0.1%
1.29	1	< 0.1%
1.48	1	< 0.1%
1.56	2	< 0.1%
1.6	1	< 0.1%
1.8	1	< 0.1%

Value	Count	Frequency (%)
5400	1	< 0.1%
510	1	< 0.1%
508	1	< 0.1%
451.5	1	< 0.1%
450	1	< 0.1%
437	1	< 0.1%
426.25	1	< 0.1%
402	1	< 0.1%
397.38	1	< 0.1%
392	2	< 0.1%

required_car_parking_spaces
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

0	111974
1	7383
2	28
3	3
8	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119390	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	119390	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

total_of_special_requests
Real number (ℝ)

Zeros

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.57136276

Minimum	0
Maximum	5
Zeros	70318
Zeros (%)	58.9%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.79279842
Coefficient of variation (CV)	1.387557
Kurtosis	1.4925648
Mean	0.57136276
Median Absolute Deviation (MAD)	0
Skewness	1.3491894
Sum	68215
Variance	0.62852934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	70318	58.9%
1	33226	27.8%
2	12969	10.9%
3	2497	2.1%
4	340	0.3%
5	40	< 0.1%

Value	Count	Frequency (%)
0	70318	58.9%
1	33226	27.8%
2	12969	10.9%
3	2497	2.1%
4	340	0.3%
5	40	< 0.1%

Value	Count	Frequency (%)
5	40	< 0.1%
4	340	0.3%
3	2497	2.1%
2	12969	10.9%
1	33226	27.8%
0	70318	58.9%

reservation_status
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Check-Out	75166
Canceled	43017
No-Show	1207

Length

Max length	9
Median length	9
Mean length	8.619474
Min length	7

Characters and Unicode

Total characters	1029079
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Check-Out
2nd row	Check-Out
3rd row	Check-Out
4th row	Check-Out
5th row	Check-Out

Common Values

Value	Count	Frequency (%)
Check-Out	75166	63.0%
Canceled	43017	36.0%
No-Show	1207	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
check-out	75166	63.0%
canceled	43017	36.0%
no-show	1207	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	161200	15.7%
C	118183	11.5%
c	118183	11.5%
h	76373	7.4%
-	76373	7.4%
u	75166	7.3%
t	75166	7.3%
O	75166	7.3%
k	75166	7.3%
a	43017	4.2%
Other values (7)	135086	13.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	756943	73.6%
Uppercase Letter	195763	19.0%
Dash Punctuation	76373	7.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	161200	21.3%
c	118183	15.6%
h	76373	10.1%
u	75166	9.9%
t	75166	9.9%
k	75166	9.9%
a	43017	5.7%
n	43017	5.7%
l	43017	5.7%
d	43017	5.7%
Other values (2)	3621	0.5%

Uppercase Letter

Value	Count	Frequency (%)
C	118183	60.4%
O	75166	38.4%
N	1207	0.6%
S	1207	0.6%

Dash Punctuation

Value	Count	Frequency (%)
-	76373	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	952706	92.6%
Common	76373	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	161200	16.9%
C	118183	12.4%
c	118183	12.4%
h	76373	8.0%
u	75166	7.9%
t	75166	7.9%
O	75166	7.9%
k	75166	7.9%
a	43017	4.5%
n	43017	4.5%
Other values (6)	92069	9.7%

Common

Value	Count	Frequency (%)
-	76373	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1029079	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	161200	15.7%
C	118183	11.5%
c	118183	11.5%
h	76373	7.4%
-	76373	7.4%
u	75166	7.3%
t	75166	7.3%
O	75166	7.3%
k	75166	7.3%
a	43017	4.2%
Other values (7)	135086	13.1%

reservation_status_date
Date

Distinct	926
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Minimum	2014-10-17 00:00:00
Maximum	2017-09-14 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

name
Text

Distinct	81503
Distinct (%)	68.3%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Length

Max length	28
Median length	26
Mean length	13.266454
Min length	6

Characters and Unicode

Total characters	1583882
Distinct characters	54
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	62855 ?
Unique (%)	52.6%

Sample

1st row	Ernest Barnes
2nd row	Andrea Baker
3rd row	Rebecca Parker
4th row	Laura Murray
5th row	Linda Hines

Value	Count	Frequency (%)
michael	2702	1.1%
smith	2558	1.0%
johnson	2028	0.8%
james	1997	0.8%
david	1968	0.8%
jennifer	1741	0.7%
christopher	1716	0.7%
robert	1686	0.7%
john	1674	0.7%
williams	1666	0.7%
Other values (1588)	224262	91.9%

Most occurring characters

Value	Count	Frequency (%)
e	147283	9.3%
a	145901	9.2%
	124608	7.9%
n	119029	7.5%
r	113938	7.2%
i	95798	6.0%
o	85735	5.4%
l	80476	5.1%
s	71585	4.5%
t	55085	3.5%
Other values (44)	544444	34.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1209024	76.3%
Uppercase Letter	247749	15.6%
Space Separator	124608	7.9%
Other Punctuation	2501	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	147283	12.2%
a	145901	12.1%
n	119029	9.8%
r	113938	9.4%
i	95798	7.9%
o	85735	7.1%
l	80476	6.7%
s	71585	5.9%
t	55085	4.6%
h	53494	4.4%
Other values (16)	240700	19.9%

Uppercase Letter

Value	Count	Frequency (%)
M	27538	11.1%
J	24332	9.8%
S	20147	8.1%
C	18738	7.6%
D	16638	6.7%
R	15503	6.3%
B	15343	6.2%
A	15319	6.2%
W	11667	4.7%
H	11435	4.6%
Other values (16)	71089	28.7%

Space Separator

Value	Count	Frequency (%)
	124608	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	2501	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1456773	92.0%
Common	127109	8.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	147283	10.1%
a	145901	10.0%
n	119029	8.2%
r	113938	7.8%
i	95798	6.6%
o	85735	5.9%
l	80476	5.5%
s	71585	4.9%
t	55085	3.8%
h	53494	3.7%
Other values (42)	488449	33.5%

Common

Value	Count	Frequency (%)
	124608	98.0%
.	2501	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1583882	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	147283	9.3%
a	145901	9.2%
	124608	7.9%
n	119029	7.5%
r	113938	7.2%
i	95798	6.0%
o	85735	5.4%
l	80476	5.1%
s	71585	4.5%
t	55085	3.5%
Other values (44)	544444	34.4%

email
Text

Distinct	115889
Distinct (%)	97.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Length

Max length	37
Median length	32
Mean length	22.216325
Min length	11

Characters and Unicode

Total characters	2652407
Distinct characters	65
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	112882 ?
Unique (%)	94.5%

Sample

1st row	Ernest.Barnes31@outlook.com
2nd row	Andrea_Baker94@aol.com
3rd row	Rebecca_Parker@comcast.net
4th row	Laura_M@gmail.com
5th row	LHines@verizon.com

Value	Count	Frequency (%)
michael.c@gmail.com	6	< 0.1%
jjohnson@hotmail.com	5	< 0.1%
andrew_s@yandex.com	5	< 0.1%
robert.m@outlook.com	5	< 0.1%
ashley_w@yahoo.com	5	< 0.1%
jmiller@gmail.com	5	< 0.1%
james.m@mail.com	5	< 0.1%
christopher.w@hotmail.com	5	< 0.1%
tjohnson@outlook.com	5	< 0.1%
asmith@yahoo.com	5	< 0.1%
Other values (115879)	119339	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
o	295499	11.1%
a	200602	7.6%
m	178799	6.7%
.	166428	6.3%
c	153386	5.8%
e	145136	5.5%
i	141662	5.3%
n	140634	5.3%
@	119390	4.5%
l	118745	4.5%
Other values (55)	992126	37.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2008574	75.7%
Other Punctuation	285818	10.8%
Uppercase Letter	241509	9.1%
Decimal Number	71926	2.7%
Connector Punctuation	44580	1.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	295499	14.7%
a	200602	10.0%
m	178799	8.9%
c	153386	7.6%
e	145136	7.2%
i	141662	7.1%
n	140634	7.0%
l	118745	5.9%
t	117440	5.8%
r	108386	5.4%
Other values (16)	408285	20.3%

Uppercase Letter

Value	Count	Frequency (%)
M	26931	11.2%
J	23884	9.9%
S	19530	8.1%
C	18307	7.6%
D	15816	6.5%
R	15149	6.3%
B	15015	6.2%
A	14996	6.2%
W	11364	4.7%
H	11176	4.6%
Other values (16)	69341	28.7%

Decimal Number

Value	Count	Frequency (%)
5	7759	10.8%
8	7740	10.8%
7	7737	10.8%
2	7681	10.7%
9	7671	10.7%
3	7670	10.7%
6	7664	10.7%
4	7529	10.5%
1	7231	10.1%
0	3244	4.5%

Other Punctuation

Value	Count	Frequency (%)
.	166428	58.2%
@	119390	41.8%

Connector Punctuation

Value	Count	Frequency (%)
_	44580	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2250083	84.8%
Common	402324	15.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	295499	13.1%
a	200602	8.9%
m	178799	7.9%
c	153386	6.8%
e	145136	6.5%
i	141662	6.3%
n	140634	6.3%
l	118745	5.3%
t	117440	5.2%
r	108386	4.8%
Other values (42)	649794	28.9%

Common

Value	Count	Frequency (%)
.	166428	41.4%
@	119390	29.7%
_	44580	11.1%
5	7759	1.9%
8	7740	1.9%
7	7737	1.9%
2	7681	1.9%
9	7671	1.9%
3	7670	1.9%
6	7664	1.9%
Other values (3)	18004	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2652407	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	295499	11.1%
a	200602	7.6%
m	178799	6.7%
.	166428	6.3%
c	153386	5.8%
e	145136	5.5%
i	141662	5.3%
n	140634	5.3%
@	119390	4.5%
l	118745	4.5%
Other values (55)	992126	37.4%

phone-number
Text

Unique

Distinct	119390
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	1432680
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	119390 ?
Unique (%)	100.0%

Sample

1st row	669-792-1661
2nd row	858-637-6955
3rd row	652-885-2745
4th row	364-656-8427
5th row	713-226-5883

Value	Count	Frequency (%)
669-792-1661	1	< 0.1%
331-430-8824	1	< 0.1%
713-226-5883	1	< 0.1%
190-271-6743	1	< 0.1%
420-332-5209	1	< 0.1%
286-669-4333	1	< 0.1%
341-726-5787	1	< 0.1%
316-648-6176	1	< 0.1%
833-887-7898	1	< 0.1%
804-383-4080	1	< 0.1%
Other values (119380)	119380	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	238780	16.7%
9	121116	8.5%
5	120923	8.4%
4	120856	8.4%
2	120832	8.4%
8	120824	8.4%
1	120781	8.4%
6	120583	8.4%
7	120275	8.4%
3	120214	8.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1193900	83.3%
Dash Punctuation	238780	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	121116	10.1%
5	120923	10.1%
4	120856	10.1%
2	120832	10.1%
8	120824	10.1%
1	120781	10.1%
6	120583	10.1%
7	120275	10.1%
3	120214	10.1%
0	107496	9.0%

Dash Punctuation

Value	Count	Frequency (%)
-	238780	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1432680	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	238780	16.7%
9	121116	8.5%
5	120923	8.4%
4	120856	8.4%
2	120832	8.4%
8	120824	8.4%
1	120781	8.4%
6	120583	8.4%
7	120275	8.4%
3	120214	8.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1432680	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	238780	16.7%
9	121116	8.5%
5	120923	8.4%
4	120856	8.4%
2	120832	8.4%
8	120824	8.4%
1	120781	8.4%
6	120583	8.4%
7	120275	8.4%
3	120214	8.4%

credit_card
Text

Distinct	9000
Distinct (%)	7.5%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	1910240
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	************4322
2nd row	************9157
3rd row	************3734
4th row	************5677
5th row	************5498

Value	Count	Frequency (%)
4923	28	< 0.1%
3627	28	< 0.1%
9864	27	< 0.1%
3972	27	< 0.1%
3793	27	< 0.1%
8794	26	< 0.1%
3352	26	< 0.1%
7474	26	< 0.1%
4681	26	< 0.1%
8172	26	< 0.1%
Other values (8990)	119123	99.8%

Most occurring characters

Value	Count	Frequency (%)
*	1432680	75.0%
6	49409	2.6%
4	49320	2.6%
3	49287	2.6%
8	49123	2.6%
9	49035	2.6%
5	48964	2.6%
1	48918	2.6%
7	48901	2.6%
2	48881	2.6%

Most occurring categories

Value	Count	Frequency (%)
Other Punctuation	1432680	75.0%
Decimal Number	477560	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	49409	10.3%
4	49320	10.3%
3	49287	10.3%
8	49123	10.3%
9	49035	10.3%
5	48964	10.3%
1	48918	10.2%
7	48901	10.2%
2	48881	10.2%
0	35722	7.5%

Other Punctuation

Value	Count	Frequency (%)
*	1432680	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1910240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
*	1432680	75.0%
6	49409	2.6%
4	49320	2.6%
3	49287	2.6%
8	49123	2.6%
9	49035	2.6%
5	48964	2.6%
1	48918	2.6%
7	48901	2.6%
2	48881	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1910240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
*	1432680	75.0%
6	49409	2.6%
4	49320	2.6%
3	49287	2.6%
8	49123	2.6%
9	49035	2.6%
5	48964	2.6%
1	48918	2.6%
7	48901	2.6%
2	48881	2.6%

Interactions

Correlations

	adr	adults	agent	arrival_date_day_of_month	arrival_date_month	arrival_date_week_number	arrival_date_year	assigned_room_type	babies	booking_changes	children	company	customer_type	days_in_waiting_list	deposit_type	distribution_channel	hotel	is_canceled	is_repeated_guest	lead_time	market_segment	meal	previous_bookings_not_canceled	previous_cancellations	required_car_parking_spaces	reservation_status	reserved_room_type	stays_in_week_nights	stays_in_weekend_nights	total_of_special_requests
adr	1.000	0.280	-0.049	0.027	0.001	0.074	0.000	0.000	0.000	0.005	0.000	0.052	0.000	-0.040	0.007	0.000	0.000	0.000	0.000	0.015	0.000	0.000	-0.143	-0.150	0.000	0.000	0.000	0.094	0.051	0.196
adults	0.280	1.000	-0.056	0.002	0.010	0.026	0.015	0.000	0.000	-0.085	0.000	0.230	0.089	-0.037	0.000	0.008	0.014	0.013	0.000	0.192	0.008	0.000	-0.210	-0.036	0.000	0.008	0.003	0.153	0.127	0.162
agent	-0.049	-0.056	1.000	0.005	0.083	-0.057	0.091	0.133	0.026	0.091	0.058	0.226	0.125	-0.019	0.119	0.209	0.817	0.086	0.076	-0.123	0.222	0.185	0.060	-0.168	0.131	0.064	0.143	0.170	0.131	0.015
arrival_date_day_of_month	0.027	0.002	0.005	1.000	0.058	0.061	0.044	0.009	0.005	0.012	0.010	0.046	0.032	0.032	0.054	0.028	0.026	0.021	0.017	0.008	0.033	0.039	-0.001	-0.012	0.008	0.023	0.010	-0.016	-0.007	0.003
arrival_date_month	0.001	0.010	0.083	0.058	1.000	0.801	0.429	0.027	0.016	0.010	0.069	0.217	0.103	0.060	0.101	0.069	0.070	0.070	0.075	0.132	0.088	0.089	0.017	0.032	0.018	0.065	0.045	0.037	0.046	0.053
arrival_date_week_number	0.074	0.026	-0.057	0.061	0.801	1.000	0.424	0.028	0.014	0.008	0.062	-0.058	0.106	-0.004	0.095	0.064	0.067	0.066	0.075	0.113	0.081	0.080	-0.043	0.087	0.017	0.061	0.042	0.026	0.026	0.019
arrival_date_year	0.000	0.015	0.091	0.044	0.429	0.424	1.000	0.053	0.009	0.016	0.044	0.281	0.213	0.074	0.052	0.027	0.043	0.026	0.010	0.104	0.159	0.112	0.025	0.052	0.018	0.023	0.082	0.014	0.029	0.091
assigned_room_type	0.000	0.000	0.133	0.009	0.027	0.028	0.053	1.000	0.044	0.051	0.304	0.085	0.090	0.029	0.192	0.095	0.391	0.203	0.071	0.062	0.121	0.116	0.003	0.008	0.092	0.145	0.776	0.047	0.051	0.066
babies	0.000	0.000	0.026	0.005	0.016	0.014	0.009	0.044	1.000	0.017	0.025	0.032	0.015	0.000	0.023	0.029	0.049	0.034	0.007	0.007	0.034	0.015	0.000	0.000	0.020	0.024	0.040	0.000	0.010	0.060
booking_changes	0.005	-0.085	0.091	0.012	0.010	0.008	0.016	0.051	0.017	1.000	0.018	0.176	0.028	-0.019	0.029	0.027	0.040	0.048	0.000	-0.008	0.020	0.011	0.031	-0.073	0.016	0.034	0.014	0.064	0.040	0.042
children	0.000	0.000	0.058	0.010	0.069	0.062	0.044	0.304	0.025	0.018	1.000	0.039	0.061	0.018	0.073	0.043	0.046	0.028	0.035	0.028	0.100	0.037	0.002	0.000	0.030	0.028	0.357	0.013	0.028	0.061
company	0.052	0.230	0.226	0.046	0.217	-0.058	0.281	0.085	0.032	0.176	0.039	1.000	0.251	0.021	0.184	0.218	0.498	0.142	0.358	0.286	0.393	0.200	-0.298	-0.198	0.048	0.106	0.098	0.250	0.076	-0.128
customer_type	0.000	0.089	0.125	0.032	0.103	0.106	0.213	0.090	0.015	0.028	0.061	0.251	1.000	0.078	0.098	0.079	0.052	0.136	0.105	0.122	0.276	0.139	0.014	0.009	0.041	0.097	0.109	0.080	0.088	0.097
days_in_waiting_list	-0.040	-0.037	-0.019	0.032	0.060	-0.004	0.074	0.029	0.000	-0.019	0.018	0.021	0.078	1.000	0.127	0.027	0.087	0.068	0.024	0.153	0.078	0.062	-0.019	0.116	0.034	0.050	0.028	0.012	-0.075	-0.123
deposit_type	0.007	0.000	0.119	0.054	0.101	0.095	0.052	0.192	0.023	0.029	0.073	0.184	0.098	0.127	1.000	0.091	0.177	0.481	0.058	0.273	0.374	0.093	0.013	0.051	0.071	0.347	0.152	0.047	0.073	0.220
distribution_channel	0.000	0.008	0.209	0.028	0.069	0.064	0.027	0.095	0.029	0.027	0.043	0.218	0.079	0.027	0.091	1.000	0.187	0.177	0.297	0.116	0.692	0.077	0.108	0.051	0.076	0.129	0.100	0.006	0.055	0.070
hotel	0.000	0.014	0.817	0.026	0.070	0.067	0.043	0.391	0.049	0.040	0.046	0.498	0.052	0.087	0.177	0.187	1.000	0.136	0.050	0.094	0.147	0.317	0.017	0.050	0.221	0.136	0.323	0.192	0.198	0.046
is_canceled	0.000	0.013	0.086	0.021	0.070	0.066	0.026	0.203	0.034	0.048	0.028	0.142	0.136	0.068	0.481	0.177	0.136	1.000	0.085	0.281	0.267	0.050	0.041	0.044	0.197	1.000	0.073	0.028	0.022	0.265
is_repeated_guest	0.000	0.000	0.076	0.017	0.075	0.075	0.010	0.071	0.007	0.000	0.035	0.358	0.105	0.024	0.058	0.297	0.050	0.085	1.000	0.134	0.347	0.060	0.320	0.185	0.078	0.086	0.037	0.017	0.082	0.040
lead_time	0.015	0.192	-0.123	0.008	0.132	0.113	0.104	0.062	0.007	-0.008	0.028	0.286	0.122	0.153	0.273	0.116	0.094	0.281	0.134	1.000	0.170	0.089	-0.189	0.171	0.057	0.207	0.048	0.296	0.162	-0.074
market_segment	0.000	0.008	0.222	0.033	0.088	0.081	0.159	0.121	0.034	0.020	0.100	0.393	0.276	0.078	0.374	0.692	0.147	0.267	0.347	0.170	1.000	0.191	0.097	0.054	0.092	0.195	0.138	0.033	0.061	0.210
meal	0.000	0.000	0.185	0.039	0.089	0.080	0.112	0.116	0.015	0.011	0.037	0.200	0.139	0.062	0.093	0.077	0.317	0.050	0.060	0.089	0.191	1.000	0.014	0.088	0.027	0.040	0.103	0.045	0.061	0.062
previous_bookings_not_canceled	-0.143	-0.210	0.060	-0.001	0.017	-0.043	0.025	0.003	0.000	0.031	0.002	-0.298	0.014	-0.019	0.013	0.108	0.017	0.041	0.320	-0.189	0.097	0.014	1.000	0.102	0.019	0.029	0.003	-0.119	-0.084	0.025
previous_cancellations	-0.150	-0.036	-0.168	-0.012	0.032	0.087	0.052	0.008	0.000	-0.073	0.000	-0.198	0.009	0.116	0.051	0.051	0.050	0.044	0.185	0.171	0.054	0.088	0.102	1.000	0.000	0.031	0.006	-0.062	-0.055	-0.129
required_car_parking_spaces	0.000	0.000	0.131	0.008	0.018	0.017	0.018	0.092	0.020	0.016	0.030	0.048	0.041	0.034	0.071	0.076	0.221	0.197	0.078	0.057	0.092	0.027	0.019	0.000	1.000	0.139	0.079	0.017	0.015	0.044
reservation_status	0.000	0.008	0.064	0.023	0.065	0.061	0.023	0.145	0.024	0.034	0.028	0.106	0.097	0.050	0.347	0.129	0.136	1.000	0.086	0.207	0.195	0.040	0.029	0.031	0.139	1.000	0.052	0.030	0.024	0.189
reserved_room_type	0.000	0.003	0.143	0.010	0.045	0.042	0.082	0.776	0.040	0.014	0.357	0.098	0.109	0.028	0.152	0.100	0.323	0.073	0.037	0.048	0.138	0.103	0.003	0.006	0.079	0.052	1.000	0.044	0.054	0.075
stays_in_week_nights	0.094	0.153	0.170	-0.016	0.037	0.026	0.014	0.047	0.000	0.064	0.013	0.250	0.080	0.012	0.047	0.006	0.192	0.028	0.017	0.296	0.033	0.045	-0.119	-0.062	0.017	0.030	0.044	1.000	0.238	0.076
stays_in_weekend_nights	0.051	0.127	0.131	-0.007	0.046	0.026	0.029	0.051	0.010	0.040	0.028	0.076	0.088	-0.075	0.073	0.055	0.198	0.022	0.082	0.162	0.061	0.061	-0.084	-0.055	0.015	0.024	0.054	0.238	1.000	0.079
total_of_special_requests	0.196	0.162	0.015	0.003	0.053	0.019	0.091	0.066	0.060	0.042	0.061	-0.128	0.097	-0.123	0.220	0.070	0.046	0.265	0.040	-0.074	0.210	0.062	0.025	-0.129	0.044	0.189	0.075	0.076	0.079	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	booking_changes	deposit_type	agent	company	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date	name	email	phone-number	credit_card
0	Resort Hotel	0	342	2015	July	27	1	0	2	BB	PRT	Direct	Direct	C	C	3	No Deposit	NaN	NaN	Transient	0.0	0	Check-Out	2015-07-01	Ernest Barnes	Ernest.Barnes31@outlook.com	669-792-1661	************4322
1	Resort Hotel	0	737	2015	July	27	1	0	2	BB	PRT	Direct	Direct	C	C	4	No Deposit	NaN	NaN	Transient	0.0	0	Check-Out	2015-07-01	Andrea Baker	Andrea_Baker94@aol.com	858-637-6955	************9157
2	Resort Hotel	0	7	2015	July	27	1	1	1	BB	GBR	Direct	Direct	A	C	0	No Deposit	NaN	NaN	Transient	75.0	0	Check-Out	2015-07-02	Rebecca Parker	Rebecca_Parker@comcast.net	652-885-2745	************3734
3	Resort Hotel	0	13	2015	July	27	1	1	1	BB	GBR	Corporate	Corporate	A	A	0	No Deposit	304.0	NaN	Transient	75.0	0	Check-Out	2015-07-02	Laura Murray	Laura_M@gmail.com	364-656-8427	************5677
4	Resort Hotel	0	14	2015	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A	0	No Deposit	240.0	NaN	Transient	98.0	1	Check-Out	2015-07-03	Linda Hines	LHines@verizon.com	713-226-5883	************5498
5	Resort Hotel	0	14	2015	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A	0	No Deposit	240.0	NaN	Transient	98.0	1	Check-Out	2015-07-03	Jasmine Fletcher	JFletcher43@xfinity.com	190-271-6743	************9263
6	Resort Hotel	0	0	2015	July	27	1	2	2	BB	PRT	Direct	Direct	C	C	0	No Deposit	NaN	NaN	Transient	107.0	0	Check-Out	2015-07-03	Dylan Rangel	Rangel.Dylan@comcast.net	420-332-5209	************6994
7	Resort Hotel	0	9	2015	July	27	1	2	2	FB	PRT	Direct	Direct	C	C	0	No Deposit	303.0	NaN	Transient	103.0	1	Check-Out	2015-07-03	William Velez	Velez_William@mail.com	286-669-4333	************8729
8	Resort Hotel	1	85	2015	July	27	1	3	2	BB	PRT	Online TA	TA/TO	A	A	0	No Deposit	240.0	NaN	Transient	82.0	1	Canceled	2015-05-06	Steven Murphy	Steven.Murphy54@aol.com	341-726-5787	************3639
9	Resort Hotel	1	75	2015	July	27	1	3	2	HB	PRT	Offline TA/TO	TA/TO	D	D	0	No Deposit	15.0	NaN	Transient	105.5	0	Canceled	2015-04-22	Michael Moore	MichaelMoore81@outlook.com	316-648-6176	************9190

	hotel	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	deposit_type	agent	company	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date	name	email	phone-number	credit_card
119380	City Hotel	44	2017	August	35	31	1	3	2	SC	DEU	Online TA	TA/TO	A	A	No Deposit	9.0	NaN	Transient	140.75	1	Check-Out	2017-09-04	Wanda Jones	Wanda_J@yandex.com	379-374-7947	************8581
119381	City Hotel	188	2017	August	35	31	2	3	2	BB	DEU	Direct	Direct	A	A	No Deposit	14.0	NaN	Transient	99.00	0	Check-Out	2017-09-05	Betty Taylor	BTaylor@yandex.com	114-632-1395	************1795
119382	City Hotel	135	2017	August	35	30	2	4	3	BB	JPN	Online TA	TA/TO	G	G	No Deposit	7.0	NaN	Transient	209.00	0	Check-Out	2017-09-05	Cesar Moreno	Cesar_M50@comcast.net	666-379-7260	************7835
119383	City Hotel	164	2017	August	35	31	2	4	2	BB	DEU	Offline TA/TO	TA/TO	A	A	No Deposit	42.0	NaN	Transient	87.60	0	Check-Out	2017-09-06	Jose Andersen	Andersen_Jose@protonmail.com	656-714-5930	************7923
119384	City Hotel	21	2017	August	35	30	2	5	2	BB	BEL	Offline TA/TO	TA/TO	A	A	No Deposit	394.0	NaN	Transient	96.14	2	Check-Out	2017-09-06	James Mccarty	James_M@att.com	689-204-7523	************7994
119385	City Hotel	23	2017	August	35	30	2	5	2	BB	BEL	Offline TA/TO	TA/TO	A	A	No Deposit	394.0	NaN	Transient	96.14	0	Check-Out	2017-09-06	Claudia Johnson	Claudia.J@yahoo.com	403-092-5582	************8647
119386	City Hotel	102	2017	August	35	31	2	5	3	BB	FRA	Online TA	TA/TO	E	E	No Deposit	9.0	NaN	Transient	225.43	2	Check-Out	2017-09-07	Wesley Aguilar	WAguilar@xfinity.com	238-763-0612	************4333
119387	City Hotel	34	2017	August	35	31	2	5	2	BB	DEU	Online TA	TA/TO	D	D	No Deposit	9.0	NaN	Transient	157.71	4	Check-Out	2017-09-07	Mary Morales	Mary_Morales@hotmail.com	395-518-4100	************1821
119388	City Hotel	109	2017	August	35	31	2	5	2	BB	GBR	Online TA	TA/TO	A	A	No Deposit	89.0	NaN	Transient	104.40	0	Check-Out	2017-09-07	Caroline Conley MD	MD_Caroline@comcast.net	531-528-1017	************7860
119389	City Hotel	205	2017	August	35	29	2	7	2	HB	DEU	Online TA	TA/TO	A	A	No Deposit	9.0	NaN	Transient	151.20	2	Check-Out	2017-09-07	Ariana Michael	Ariana_M@xfinity.com	422-804-6403	************4482

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script